# -*- coding: utf-8 -*-

# Scrapy settings for datascrapy project
#
# For simplicity, this file contains only settings considered important or
# commonly used. You can find more settings consulting the documentation:
#
#     https://docs.scrapy.org/en/latest/topics/settings.html
#     https://docs.scrapy.org/en/latest/topics/downloader-middleware.html
#     https://docs.scrapy.org/en/latest/topics/spider-middleware.html

BOT_NAME = 'datascrapy'

ALLOWED_DOMAINS = ['dbms.itsm.cnxxxxsuxxxxning.com']
START_URLS = ['http://dbms.itsm.cnxxxxsuxxxxning.com/']

SPIDER_MODULES = ['datascrapy.spiders']
NEWSPIDER_MODULE = 'datascrapy.spiders'

# Crawl responsibly by identifying yourself (and your website) on the user-agent
# USER_AGENT = 'datascrapy (+http://www.yourdomain.com)'

# Obey robots.txt rules
ROBOTSTXT_OBEY = False

# Mysql host
MYSQL_HOST = '10.37.29.233'
# 连接端口号
MYSQL_PORT = 3306
# Mysql用户名
MYSQL_USER = 'xxxxx'
# Mysql用户密码
MYSQL_PASS = 'xxxxx'
# Mysql数据库名
MYSQL_DB = 'xxxxx'
# Mysql数据库名
MYSQL_CON_NUM = 5

# redis host
REDIS_HOST = "127.0.0.1"
# redis port
REDIS_PORT = 6379

COOKIE = "XXXX "

HEADERS = {
    "Accept": "text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,image/apng,*/*;q=0.8",
    "Accept-Encoding": "gzip, deflate",
    "Accept-Language": "zh-CN,zh;q=0.9",
    "Cache-Control": "max-age=0",
    "Connection": "keep-alive",
    "Cookie": COOKIE + "dbms=eyJfZnJlc2giOnRydWUsIl9pZCI6eyIgYiI6Ik16aGhPRGcxWWpreE1qRmxZekJqTkRkaFlUVmpNRFppTldOaU9HTTVNakE9In0sIm5pY2tuYW1lIjoiXHU4NjVlXHU0ZTkxXHU2Y2UyIiwidXNlcl9pZCI6IjE4MDg4NzA0In0.Efvfew.hVXPjv92yMTpwGqMHrZa9pxiYpY;",
    "Host": "dbms.itsm.cnxxxxsuxxxxning.com",
    "Upgrade-Insecure-Requests": "1",
    "User-Agent": "Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/66.0.3359.181 Safari/537.36"
}

URL = "http://dbms.itsm.cnxxxxsuxxxxning.com/"

DATAHEADERS = {
    "Accept": "*/*",
    "Accept-Encoding": "gzip, deflate",
    "Accept-Language": "zh-CN,zh;q=0.9",
    "Connection": "keep-alive",
    "Cookie": COOKIE,
    "Host": "dbms.itsm.cnxxxxsuxxxxning.com",
    "Referer": "http://dbms.itsm.cnxxxxsuxxxxning.com/object-browser/table?db=106804589&type=3&host=10.102.66.56&name=jwmsprd16",
    "User-Agent": "Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/66.0.3359.181 Safari/537.36",
    "X-Requested-With": "XMLHttpRequest"
}

COOKIE_KEY = "cookie_key"
SYSNAME = "JWMS"

# Configure maximum concurrent requests performed by Scrapy (default: 16)
# CONCURRENT_REQUESTS = 32

# Configure a delay for requests for the same website (default: 0)
# See https://docs.scrapy.org/en/latest/topics/settings.html#download-delay
# See also autothrottle settings and docs
# DOWNLOAD_DELAY = 3
# The download delay setting will honor only one of:
# CONCURRENT_REQUESTS_PER_DOMAIN = 16
# CONCURRENT_REQUESTS_PER_IP = 16

# Disable cookies (enabled by default)
# COOKIES_ENABLED = False

# Disable Telnet Console (enabled by default)
# TELNETCONSOLE_ENABLED = False

# Override the default request headers:
# DEFAULT_REQUEST_HEADERS = {
#   'Accept': 'text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8',
#   'Accept-Language': 'en',
# }

# Enable or disable spider middlewares
# See https://docs.scrapy.org/en/latest/topics/spider-middleware.html
# SPIDER_MIDDLEWARES = {
#    'datascrapy.middlewares.DatascrapySpiderMiddleware': 543,
# }

# Enable or disable downloader middlewares
# See https://docs.scrapy.org/en/latest/topics/downloader-middleware.html
# DOWNLOADER_MIDDLEWARES = {
#    'datascrapy.middlewares.DatascrapyDownloaderMiddleware': 543,
# }

# Enable or disable extensions
# See https://docs.scrapy.org/en/latest/topics/extensions.html
# EXTENSIONS = {
#    'scrapy.extensions.telnet.TelnetConsole': None,
# }

# Configure item pipelines
# See https://docs.scrapy.org/en/latest/topics/item-pipeline.html
ITEM_PIPELINES = {
    'datascrapy.pipelines.DbrowScrapyPipeline': 300,
    'datascrapy.pipelines.DbSlowSqlScrapyPipeline': 301,
    'datascrapy.pipelines.TableInfoScrapyPipeline': 302,
    'datascrapy.pipelines.DbFileInfoScrapyPipeline': 303
}

# Enable and configure the AutoThrottle extension (disabled by default)
# See https://docs.scrapy.org/en/latest/topics/autothrottle.html
# AUTOTHROTTLE_ENABLED = True
# The initial download delay
# AUTOTHROTTLE_START_DELAY = 5
# The maximum download delay to be set in case of high latencies
# AUTOTHROTTLE_MAX_DELAY = 60
# The average number of requests Scrapy should be sending in parallel to
# each remote server
# AUTOTHROTTLE_TARGET_CONCURRENCY = 1.0
# Enable showing throttling stats for every response received:
# AUTOTHROTTLE_DEBUG = False

# Enable and configure HTTP caching (disabled by default)
# See https://docs.scrapy.org/en/latest/topics/downloader-middleware.html#httpcache-middleware-settings
# HTTPCACHE_ENABLED = True
# HTTPCACHE_EXPIRATION_SECS = 0
# HTTPCACHE_DIR = 'httpcache'
# HTTPCACHE_IGNORE_HTTP_CODES = []
# HTTPCACHE_STORAGE = 'scrapy.extensions.httpcache.FilesystemCacheStorage'
